package com.grq.mis.dao;

import com.grq.mis.entity.Item;
import org.beetl.sql.mapper.BaseMapper;
import org.beetl.sql.mapper.annotation.Sql;
import org.beetl.sql.mapper.annotation.SqlResource;
import org.springframework.stereotype.Repository;

@SqlResource("item")
@Repository
public interface ItemDao extends BaseMapper<Item> {

    @Sql("select count(*) from t_item")
    long allItem();

    @Sql("select count(*) from t_item where DATE_FORMAT(create_time, '%Y-%m-%d') = ?")
    long todayItem(String today);
}
